CREATE TABLE [dbo].[Activity]
(
[SEQN] [int] NOT NULL CONSTRAINT [DF_Activity_SEQN] DEFAULT ((0)),
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_ID] DEFAULT (''),
[ACTIVITY_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_ACTIVITY_TYPE] DEFAULT (''),
[TRANSACTION_DATE] [datetime] NULL,
[EFFECTIVE_DATE] [datetime] NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_PRODUCT_CODE] DEFAULT (''),
[OTHER_CODE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_OTHER_CODE] DEFAULT (''),
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_DESCRIPTION] DEFAULT (''),
[SOURCE_SYSTEM] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_SOURCE_SYSTEM] DEFAULT (''),
[SOURCE_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_SOURCE_CODE] DEFAULT (''),
[QUANTITY] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Activity_QUANTITY] DEFAULT ((0)),
[AMOUNT] [money] NOT NULL CONSTRAINT [DF_Activity_AMOUNT] DEFAULT ((0)),
[CATEGORY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_CATEGORY] DEFAULT (''),
[UNITS] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Activity_UNITS] DEFAULT ((0)),
[THRU_DATE] [datetime] NULL,
[MEMBER_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_MEMBER_TYPE] DEFAULT (''),
[ACTION_CODES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_ACTION_CODES] DEFAULT (''),
[PAY_METHOD] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_PAY_METHOD] DEFAULT (''),
[TICKLER_DATE] [datetime] NULL,
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE_2] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BATCH_NUM] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_BATCH_NUM] DEFAULT (''),
[CO_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_CO_ID] DEFAULT (''),
[OBJECT] [image] NULL,
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_INTENT_TO_EDIT] DEFAULT (''),
[UF_1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_UF_1] DEFAULT (''),
[UF_2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_UF_2] DEFAULT (''),
[UF_3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_UF_3] DEFAULT (''),
[UF_4] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Activity_UF_4] DEFAULT ((0)),
[UF_5] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Activity_UF_5] DEFAULT ((0)),
[UF_6] [datetime] NULL,
[UF_7] [datetime] NULL,
[ORIGINATING_TRANS_NUM] [int] NOT NULL CONSTRAINT [DF_Activity_ORIGINATING_TRANS_NUM] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_ORG_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_CAMPAIGN_CODE] DEFAULT (''),
[OTHER_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_OTHER_ID] DEFAULT (''),
[SOLICITOR_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_SOLICITOR_ID] DEFAULT (''),
[TAXABLE_VALUE] [money] NOT NULL CONSTRAINT [DF_Activity_TAXABLE_VALUE] DEFAULT ((0)),
[ATTACH_SEQN] [int] NOT NULL CONSTRAINT [DF_Activity_ATTACH_SEQN] DEFAULT ((0)),
[ATTACH_TOTAL] [int] NOT NULL CONSTRAINT [DF_Activity_ATTACH_TOTAL] DEFAULT ((0)),
[RECURRING_REQUEST] [bit] NOT NULL CONSTRAINT [DF_Activity_RECURRING_REQUEST] DEFAULT ((0)),
[STATUS_CODE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NEXT_INSTALL_DATE] [datetime] NULL,
[GRACE_PERIOD] [int] NULL,
[MEM_TRIB_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Activity_MEM_TRIB_CODE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Activity] ADD CONSTRAINT [PK_Activity] PRIMARY KEY NONCLUSTERED ([SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityACTIVITY_TYPE] ON [dbo].[Activity] ([ACTIVITY_TYPE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityCAMPAIGN_CODE] ON [dbo].[Activity] ([CAMPAIGN_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityCO_ID] ON [dbo].[Activity] ([CO_ID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iActivityID] ON [dbo].[Activity] ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityORG_CODE] ON [dbo].[Activity] ([ORG_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityORIGINATING_TRANS_NUM] ON [dbo].[Activity] ([ORIGINATING_TRANS_NUM], [SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityADDITIONAL_NAME_ID] ON [dbo].[Activity] ([OTHER_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityPRODUCT_CODE] ON [dbo].[Activity] ([PRODUCT_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivitySeqnActivityTypeID] ON [dbo].[Activity] ([SEQN], [ID], [ACTIVITY_TYPE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivitySOLICITOR_ID] ON [dbo].[Activity] ([SOLICITOR_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivitySOURCE_CODE] ON [dbo].[Activity] ([SOURCE_CODE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivitySOURCE_SYSTEM] ON [dbo].[Activity] ([SOURCE_SYSTEM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityTICKLER_DATE] ON [dbo].[Activity] ([TICKLER_DATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityTRANSACTION_DATE] ON [dbo].[Activity] ([TRANSACTION_DATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityUF_4] ON [dbo].[Activity] ([UF_4]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iActivityUF_5] ON [dbo].[Activity] ([UF_5]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Activity] TO [IMIS]
GRANT SELECT ON  [dbo].[Activity] TO [IMIS]
GRANT INSERT ON  [dbo].[Activity] TO [IMIS]
GRANT DELETE ON  [dbo].[Activity] TO [IMIS]
GRANT UPDATE ON  [dbo].[Activity] TO [IMIS]
GO